home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presentation Library 1993 Spring / ARPL-Spring-93-Partner-Edition.iso / Applications / Databases / GQL V3.0 Demo / USA Sales Information / USA Sales Information.rsrc / QRY_16868_Large Orders < prev    next >
Encoding:
Text File  |  1992-01-27  |  377 b   |  1 lines

  1. 100800customer100500order100600placed1400000201140000050114001002011400100301130100000056 000158 000076 000168 001105000010030052000015160010020006placed05order160000020008customer06placed200000180select customer.cust_name, customer.cust_city, orders.ord_date, orders.ord_amount from customer, orders where ((orders.ord_amount > 20000)) and customer.cust_num = orders.cust_nr ;